﻿CREATE TABLE [dbo].[Finance_Report] (
    [Id]              INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CompanyId]       INT             NULL,
    [CompanyName]     NVARCHAR (50)   NULL,
    [CashIn]          DECIMAL (18, 2) NULL,
    [CashOut]         DECIMAL (18, 2) NULL,
    [BankIn]          DECIMAL (18, 2) NULL,
    [BankOut]         DECIMAL (18, 2) NULL,
    [PingZhengIn]     DECIMAL (18, 2) NULL,
    [PingZhengOut]    DECIMAL (18, 2) NULL,
    [XZML]            DECIMAL (18, 2) NULL,
    [XFML]            DECIMAL (18, 2) NULL,
    [XZYS]            DECIMAL (18, 2) NULL,
    [CostPriceAll]    DECIMAL (18, 2) NULL,
    [CostPriceFinish] DECIMAL (18, 2) NULL,
    [WKSR]            DECIMAL (18, 2) NULL,
    [Total]           DECIMAL (18, 2) NULL,
    [CreateDate]      DATETIME        NULL,
    [ShengChengDate]  DATETIME        NULL,
    CONSTRAINT [PK_Finance_Report] PRIMARY KEY CLUSTERED ([Id] ASC)
);

